{ "cells": [ { "cell_type": "markdown", "id": "b77436f2", "metadata": {}, "source": [ "# Project 1" ] }, { "cell_type": "markdown", "id": "64d353e3", "metadata": {}, "source": [ "Health Insurance Coverage :)" ] }, { "cell_type": "markdown", "id": "2c86fa26", "metadata": {}, "source": [ "## Importing Data" ] }, { "cell_type": "code", "execution_count": 3, "id": "64b5a3f0", "metadata": {}, "outputs": [], "source": [ "import pandas as pd # for making with data\n", "import numpy as np # for making with data" ] }, { "cell_type": "markdown", "id": "5284d306", "metadata": {}, "source": [ "## Load Data" ] }, { "cell_type": "code", "execution_count": 4, "id": "6917ecd4", "metadata": {}, "outputs": [], "source": [ "df = pd.read_csv(\"states.csv\")" ] }, { "cell_type": "code", "execution_count": 5, "id": "98e586a4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | State | \n", "Uninsured Rate (2010) | \n", "Uninsured Rate (2015) | \n", "Uninsured Rate Change (2010-2015) | \n", "Health Insurance Coverage Change (2010-2015) | \n", "Employer Health Insurance Coverage (2015) | \n", "Marketplace Health Insurance Coverage (2016) | \n", "Marketplace Tax Credits (2016) | \n", "Average Monthly Tax Credit (2016) | \n", "State Medicaid Expansion (2016) | \n", "Medicaid Enrollment (2013) | \n", "Medicaid Enrollment (2016) | \n", "Medicaid Enrollment Change (2013-2016) | \n", "Medicare Enrollment (2016) | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Alabama | \n", "14.6% | \n", "10.1% | \n", "-4.5% | \n", "215000 | \n", "2545000 | \n", "165534 | \n", "152206 | \n", "$310 | \n", "False | \n", "799176.0 | \n", "910775 | \n", "111599.0 | \n", "989855 | \n", "
1 | \n", "Alaska | \n", "19.9% | \n", "14.9% | \n", "-5% | \n", "36000 | \n", "390000 | \n", "17995 | \n", "16205 | \n", "$750 | \n", "True | \n", "122334.0 | \n", "166625 | \n", "44291.0 | \n", "88966 | \n", "
2 | \n", "Arizona | \n", "16.9% | \n", "10.8% | \n", "-6.1% | \n", "410000 | \n", "3288000 | \n", "179445 | \n", "124346 | \n", "$230 | \n", "True | \n", "1201770.0 | \n", "1716198 | \n", "514428.0 | \n", "1175624 | \n", "
3 | \n", "Arkansas | \n", "17.5% | \n", "9.5% | \n", "-8% | \n", "234000 | \n", "1365000 | \n", "63357 | \n", "56843 | \n", "$306 | \n", "True | \n", "556851.0 | \n", "920194 | \n", "363343.0 | \n", "606146 | \n", "
4 | \n", "California | \n", "18.5% | \n", "8.6% | \n", "-9.9% | \n", "3826000 | \n", "19552000 | \n", "1415428 | \n", "1239893 | \n", "$309 | \n", "True | \n", "7755381.0 | \n", "11843081 | \n", "4087700.0 | \n", "5829777 | \n", "
\n", " | State | \n", "Uninsured Rate (2010) | \n", "Uninsured Rate (2015) | \n", "Health Insurance Coverage Change (2010-2015) | \n", "Employer Health Insurance Coverage (2015) | \n", "Marketplace Health Insurance Coverage (2016) | \n", "Marketplace Tax Credits (2016) | \n", "Average Monthly Tax Credit (2016) | \n", "State Medicaid Expansion (2016) | \n", "Medicaid Enrollment (2013) | \n", "... | \n", "Uninsured Rate Change (2010-2015)_ -6.6% | \n", "Uninsured Rate Change (2010-2015)_ -6.7% | \n", "Uninsured Rate Change (2010-2015)_ -7.6% | \n", "Uninsured Rate Change (2010-2015)_ -7.8% | \n", "Uninsured Rate Change (2010-2015)_ -8% | \n", "Uninsured Rate Change (2010-2015)_ -8.6% | \n", "Uninsured Rate Change (2010-2015)_ -8.7% | \n", "Uninsured Rate Change (2010-2015)_ -9.3% | \n", "Uninsured Rate Change (2010-2015)_ -9.9% | \n", "Uninsured Rate Change (2010-2015)_6.1% | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Alabama | \n", "14.6% | \n", "10.1% | \n", "215000 | \n", "2545000 | \n", "165534 | \n", "152206 | \n", "$310 | \n", "False | \n", "799176.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1 | \n", "Alaska | \n", "19.9% | \n", "14.9% | \n", "36000 | \n", "390000 | \n", "17995 | \n", "16205 | \n", "$750 | \n", "True | \n", "122334.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
2 | \n", "Arizona | \n", "16.9% | \n", "10.8% | \n", "410000 | \n", "3288000 | \n", "179445 | \n", "124346 | \n", "$230 | \n", "True | \n", "1201770.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
3 | \n", "Arkansas | \n", "17.5% | \n", "9.5% | \n", "234000 | \n", "1365000 | \n", "63357 | \n", "56843 | \n", "$306 | \n", "True | \n", "556851.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
4 | \n", "California | \n", "18.5% | \n", "8.6% | \n", "3826000 | \n", "19552000 | \n", "1415428 | \n", "1239893 | \n", "$309 | \n", "True | \n", "7755381.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
5 rows × 53 columns
\n", "